<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Northwind" assembly="NHibernate.Class">
    <class name="Northwind.Supplier, NHibernate.Class" table="[dbo].[Suppliers]" lazy="true">
        <id name="SupplierID" type="Int32">
            <column name="SupplierID" not-null="false" unique="true" />
            <generator class="native" />
        </id>
        <property name="CompanyName" type="String">
            <column name="CompanyName" length="40" not-null="true" />
        </property>
        <property name="ContactName" type="String">
            <column name="ContactName" length="30" not-null="false" />
        </property>
        <property name="ContactTitle" type="String">
            <column name="ContactTitle" length="30" not-null="false" />
        </property>
        <property name="Address" type="String">
            <column name="Address" length="60" not-null="false" />
        </property>
        <property name="City" type="String">
            <column name="City" length="15" not-null="false" />
        </property>
        <property name="Region" type="String">
            <column name="Region" length="15" not-null="false" />
        </property>
        <property name="PostalCode" type="String">
            <column name="PostalCode" length="10" not-null="false" />
        </property>
        <property name="Country" type="String">
            <column name="Country" length="15" not-null="false" />
        </property>
        <property name="Phone" type="String">
            <column name="Phone" length="24" not-null="false" />
        </property>
        <property name="Fax" type="String">
            <column name="Fax" length="24" not-null="false" />
        </property>
        <property name="HomePage" type="String">
            <column name="HomePage" length="1073741823" not-null="false" />
        </property>
        <bag name="Products" lazy="true" inverse="true" cascade="all-delete-orphan">
            <key column="SupplierID" />
            <one-to-many class="Product" />
        </bag>
    </class>
</hibernate-mapping>

